Topic: Manual and Automatic Sorting in Tableau
Learning Objective: Understand how to manually arrange dimension members, automatically sort data using alphabetical or measure-based rules, configure sorting options, and apply the correct sorting method to business reports and dashboards.
Course Link: JustAcademy Tableau Training
Demo Link: Register for a Tableau Course Demo
Sorting is an important feature in Tableau that arranges data into a meaningful order. It helps users identify high-performing products, compare regional sales, organize categories, and make business reports easier to understand.
Tableau provides different sorting approaches. Two important approaches are manual sorting and automatic sorting.
Manual sorting allows users to control the order of individual dimension members by dragging headers, rearranging legend items, or configuring a manual order in the Sort dialog.
Automatic sorting arranges dimension members according to a defined sorting rule, such as alphabetical order, ascending or descending measure values, or a field-based sort. When the data or view changes, Tableau can recalculate a computed sort according to its configured rule.
Suppose a company wants to display the following product categories:
| Category | Sales |
|---|---|
| Furniture | 75,000 |
| Technology | 120,000 |
| Office Supplies | 45,000 |
If the company wants categories arranged by sales from highest to lowest, automatic measure-based sorting is suitable. If the company wants them displayed in a business-defined sequence regardless of sales, manual sorting is more appropriate.
Manual sorting is a sorting technique in which the user explicitly decides the order of dimension members. Instead of relying on alphabetical order or a numerical measure, the user places the values in the required sequence.
Manual sorting is particularly useful when the desired order follows business logic rather than numerical performance.
Suppose a business wants the categories displayed in this order:
This order may not match alphabetical order or sales performance. Manual sorting allows the user to define the preferred sequence.
This method lets you reposition a dimension member by dragging its header to the required location.
Original order:
Required manual order:
Drag Technology to the first position, then reposition the remaining categories if necessary.
The Sort dialog provides a more structured way to define a custom sequence.
The exact controls available depend on the field, visualization, and Tableau authoring environment.
A legend may display the members of a dimension represented by different colors or marks. In supported views, these members can be manually reordered.
Important: Reordering a legend can also change the order of marks in the visualization. It does not necessarily change only the visual order of the legend items.
Automatic sorting is the process of arranging dimension members according to a sorting rule rather than manually placing every member in a custom sequence. Common automatic sorting rules include alphabetical order, data-source order, and sorting by an aggregated measure.
For example, a product chart can be configured to sort products by SUM(Sales) in descending order. Tableau determines the position of each product using the configured sorting rule.
Note: Automatic sorting is not a single dedicated button or one universal setting. Tableau offers several sorting controls and configurations that establish a rule for ordering the data.
| Sorting Type | Description | Example |
|---|---|---|
| Alphabetical Sorting | Arranges text values alphabetically. | Customers from A to Z. |
| Numerical or Measure-Based Sorting | Orders dimension members according to a measure. | Products by total sales. |
| Ascending Sorting | Arranges values from low to high, or in the corresponding ascending order for the field type. | Regions by lowest to highest profit. |
| Descending Sorting | Arranges values from high to low, or in the corresponding descending order for the field type. | Regions by highest to lowest profit. |
| Data-Source-Order Sorting | Uses the order supplied by the data source or its defined member order. | Preserve a source-defined category order. |
| Nested Sorting | Sorts dimension members within relevant groups or panes. | Sort subcategories separately within each region. |
A suitable header may provide a sort control that allows users to rearrange the members displayed in a view.
In Tableau's documented quick-sort behavior, the first click sorts descending, the second sorts ascending, and the third clears the sort. The available controls depend on the visualization.
The toolbar provides ascending and descending sort buttons for supported views.
Important: If you do not select a field first, Tableau may sort the deepest dimension in the view. Toolbar sorting can also use the leftmost measure in the view, so check the sort logic when multiple measures are present.
The Sort menu gives you more control over the field and aggregation used to determine the order.
| Product | Sales |
|---|---|
| Laptop | 80,000 |
| Mouse | 12,000 |
| Monitor | 35,000 |
| Mobile | 95,000 |
Configure the Product dimension to sort by SUM(Sales) in descending order.
| Display Order | Product | Sales |
|---|---|---|
| 1 | Mobile | 95,000 |
| 2 | Laptop | 80,000 |
| 3 | Monitor | 35,000 |
| 4 | Mouse | 12,000 |
The order is determined by the measure values rather than by the user's manual placement of each product.
| Feature | Manual Sorting | Automatic Sorting |
|---|---|---|
| Definition | The user defines the order of individual members. | Tableau arranges members according to a configured sorting rule. |
| Control | Direct control over member positions. | Control over the rule, field, aggregation, and direction. |
| Typical method | Drag headers or rearrange members in a Manual Sort dialog. | Use sort controls or configure a field-based sort. |
| Business-defined order | Well suited to custom business sequences. | Suitable when a standard rule provides the intended sequence. |
| Measure-based order | Does not automatically reorder members according to changing measure values. | Can order members according to a measure such as SUM(Sales). |
| Response to data changes | The existing custom sequence may remain, but new members may require manual review. | A computed sort can recalculate according to the configured rule when relevant data changes. |
| Best use | Workflow stages, priorities, and presentation order. | Sales rankings, profit comparisons, alphabetical lists, and changing reports. |
| Main limitation | Requires manual maintenance when the required sequence changes. | May produce an unexpected order if the wrong field or aggregation is selected. |
Scenario: A project manager wants project statuses displayed in the order followed by the team.
| Project | Status |
|---|---|
| Website Redesign | Testing |
| Mobile App | Planning |
| CRM Upgrade | Completed |
| Analytics Dashboard | Development |
Alphabetical sorting would not follow the team's workflow. The required order is:
Business benefit: The report communicates the team's workflow clearly, even though the desired sequence is neither alphabetical nor based on a numerical measure.
Scenario: A sales manager wants to see the strongest products first.
| Product | Sales | Profit |
|---|---|---|
| Keyboard | 18,000 | 4,500 |
| Laptop | 80,000 | 12,000 |
| Mobile | 95,000 | 15,000 |
| Monitor | 35,000 | 6,000 |
| Order | Product | Sales |
|---|---|---|
| 1 | Mobile | 95,000 |
| 2 | Laptop | 80,000 |
| 3 | Monitor | 35,000 |
| 4 | Keyboard | 18,000 |
Business benefit: The manager can quickly identify the highest-selling product and compare the performance of the remaining products.
The correct sorting method depends on the purpose of the analysis.
| Requirement | Recommended Approach | Reason |
|---|---|---|
| Display customers from A to Z. | Automatic alphabetical sort | The order follows a standard text rule. |
| Show the highest-selling products first. | Automatic measure-based sort | The order follows sales values. |
| Display project stages in workflow order. | Manual sort | The sequence follows business logic. |
| Arrange priority labels in a custom sequence. | Manual sort | The order does not depend on alphabetical position. |
| Show the most profitable regions first. | Automatic measure-based sort | The order follows profit values. |
| Keep a predefined order for a presentation. | Manual sort or a defined custom-order field | The presentation requires a specific sequence. |
| Display months chronologically. | Automatic date-based sort | A real date field preserves the calendar sequence. |
Tableau views may contain multiple dimensions, such as Region, Category, and Product. In these cases, the selected sorting method affects how values are arranged within the view.
A company wants to analyze sales by Region and Category. There are two possible requirements:
The first requirement may call for a nested sort. The second may call for a non-nested sort. Manual sorting can be useful when the desired order is a fixed business sequence.
When a result appears incorrectly sorted, inspect the sort settings, the dimension being sorted, the selected measure, and whether the sort is nested.
Understanding how sorting responds to changes is important when building reports that are refreshed regularly.
A manual order is based on the member sequence defined by the user. If new products, regions, or categories are introduced, the user may need to review the order and decide where new members belong.
A computed sort uses a rule, such as descending SUM(Sales). When the underlying values change and the view is recalculated, Tableau can update the positions according to that rule.
Suppose Product A has sales of 50,000 and Product B has sales of 40,000. An automatic descending sort places Product A first. If a later refresh changes Product B's sales to 60,000, the computed sort can place Product B first.
With a manual sort, Product A may remain before Product B because the sequence was explicitly defined by the user, unless the user changes it.
Important: The behavior of a saved sort depends on its configuration, the view, filters, and available data. Always verify the result after refreshing or modifying a workbook.
| Problem | Possible Reason | Solution |
|---|---|---|
| Categories are in alphabetical order instead of the desired order. | An alphabetical sort is active. | Use Manual sorting or choose the correct field-based sort. |
| Products are sorted by the wrong measure. | The sort uses a different measure or default field. | Inspect the Sort dialog and explicitly choose the intended field and aggregation. |
| The manual order is difficult to maintain. | New dimension members are added regularly. | Review the custom order or consider a defined business-order field. |
| The sort direction is reversed. | Ascending was selected instead of descending, or vice versa. | Check the direction and confirm the intended highest or lowest value. |
| Months appear alphabetically. | Month names are treated as text. | Use a proper date field or a numeric month-order field. |
| Different panes show different category orders. | A nested sort is active. | Check whether a non-nested sort is more suitable. |
| The sort control is missing. | The view may not support that control, or sort icons may be hidden. | Check the visualization and available menu options. |
| Manual sorting is not available as expected. | The selected field or view may not support the desired manual-sort operation. | Try the field's Sort menu or a supported header or legend interaction. |
Task: Arrange Technology, Furniture, and Office Supplies in the order Technology, Furniture, Office Supplies.
Goal: Practice manually repositioning dimension members.
Task: Create a bar chart of products and sales. Sort by SUM(Sales) in descending order.
Goal: Identify the highest-selling product.
Task: Create a customer list and arrange names alphabetically.
Goal: Understand automatic text sorting.
Task: Arrange Low, Medium, High, and Critical in that exact sequence.
Goal: Apply a custom business order.
Task: Create a regional profit chart and sort regions from highest to lowest SUM(Profit).
Goal: Compare profitability across regions.
Task: Apply a manual category order, then change the sort to descending SUM(Sales).
Goal: Observe how the same dimension is ordered differently by a fixed sequence and a measure-based rule.
Project Objective: Build a Tableau dashboard that uses manual and automatic sorting to present product performance, regional profitability, and business categories clearly.
Answer: Manual sorting allows users to specify the order of dimension members by dragging headers or legend items or by using the Manual option in the Sort dialog, where available.
Answer: Automatic sorting arranges members according to a configured rule, such as alphabetical order, data-source order, or values from an aggregated measure.
Answer: Manual sorting uses a user-defined sequence. Automatic sorting uses a sorting rule to determine the order of members.
Answer: Use manual sorting when the required order follows business logic, such as project stages, priority levels, or a custom presentation sequence.
Answer: Use automatic sorting when members should follow a standard or computed rule, such as ranking products by sales or sorting names alphabetically.
Answer: Create a view containing the categories, then drag the headers into the desired sequence or use the field's Sort menu and select Manual, if available.
Answer: Open the Product sort settings, choose Field, select Sales and SUM as the aggregation, and select descending order.
Answer: A computed sort can recalculate when relevant data changes, according to the configured rule. The result should be checked after refreshing the data or changing filters.
Answer: No. Manual sorting defines a custom sequence rather than automatically ranking members according to changing sales values.
Answer: Yes, in supported views. Legend members can be reordered using the available manual-sort controls. Reordering a legend can also affect mark order in the visualization.
Answer: Tableau may be using a different field, aggregation, dimension, or nested-sort context than intended. Inspect the Sort menu and the view structure.
Answer: SUM(Sales) orders members by their total sales, whereas AVG(Sales) orders them by average sales values. These can produce different rankings.
Answer: Nested sorting orders members within individual groups or panes, so the order may differ across groups.
Answer: Use the field's Clear Sort option when available or use the worksheet's Clear Sorts command.
Answer: Manual sorting supports meaningful custom sequences, while automatic sorting makes performance comparisons and frequently updated rankings easier to maintain.
Manual and automatic sorting are two useful approaches for organizing Tableau visualizations. Manual sorting is ideal when users need a specific business-defined order, while automatic sorting is better suited to alphabetical lists, chronological sequences, and rankings based on measures.
By understanding how to drag dimension members, configure the Sort dialog, choose the correct aggregation, and check sorting behavior after data changes, users can build clearer reports and more effective dashboards.
Next Step: Practice creating the same product chart using manual sorting and automatic sorting by SUM(Sales). Compare the results and decide which method best supports the business question.
